package com.kim.rssreader.domain.constant;

public class RssImageConstant {

	public static final String TABLE_NAME = "rss_image";

	public static final String KEY = "_id"; // 'rss文章内容图片id'
	public static final String RSSIMAGEURL = "_rssimageurl"; // 'rss文章内容图片地址'
	public static final String RSSIMAGESIZE = "_rssimagesize"; // 'rss文章内容图片大小'
	public static final String CONTENTURL = "_contenturl"; // 'rss文章内容url'

	public static final int RSSIMAGE_Key = 0; // 'rss文章内容id'
	public static final int RSSIMAGE_RSSIMAGEURL = 1; // 'rss文章内容唯一标识'
	public static final int RSSIMAGE_RSSIMAGESIZE = 2; // 'rss文章内容图片大小'
	public static final int RSSIMAGE_CONTENTIDURL = 3; // 'rss文章内容标题'

	public static final String[] COLUMNS = new String[] { KEY, RSSIMAGEURL,
			RSSIMAGESIZE, CONTENTURL };

	public static final String SQL_CREATE = "CREATE TABLE IF NOT EXISTS `rss_image` ("
			+ "`_id` INTEGER PRIMARY KEY AUTOINCREMENT,"
			+ "`_rssimageurl` VARCHAR(100) NOT NULL,"
			+ "`_rssimagesize` int NOT NULL,"
			+ "`_contenturl` VARCHAR(100) NOT NULL, unique(`_rssimageurl`) ON CONFLICT IGNORE )";
}
